package com.cg.cgms.mapper;

import com.cg.cgms.pojo.Food;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.ArrayList;

@Mapper
public interface FoodMapper {
    @Select("select * from food where ssid=#{ssid}")
    ArrayList<Food> findBYSsid(Integer ssid);

    @Select("select * from food where name like concat('%',#{name},'%')")
    ArrayList<Food> findByName(String name);
    @Select("select * from food where money> #{minMoney} and money< #{maxMoney}")
    ArrayList<Food> findByMoney(float minMoney, float maxMoney);
}
